﻿if exists (select * from dbo.sysobjects where name = 'sp_tblOrder_GetBy_sid')
	drop procedure [dbo].[sp_tblOrder_GetBy_sid]
Go 
CREATE PROCEDURE dbo.sp_tblOrder_GetBy_sid
@_sid int
AS
	SELECT * FROM tblOrder
 WHERE _sid = @_sid 
Goif exists (select * from dbo.sysobjects where name = 'sp_tblOrder_GetBy_uid')
	drop procedure [dbo].[sp_tblOrder_GetBy_uid]
Go 
CREATE PROCEDURE dbo.sp_tblOrder_GetBy_uid
@_uid int
AS
	SELECT * FROM tblOrder
 WHERE _uid = @_uid 
Go